I have setup a checkbox field on a profile document that looks into another database to populate the choices. (this works fine)
FIELD
Data:=Data;
temp:=@DbLookup("": "NoCache" ; "" : "" ;"DataLookup" ;"DATA";2);
@SetField("Data";@Unique(temp))
I have a form that has a similar checkbox field I want to populate the choices using a formula based on the the profile document field. The reason I do this I do not want to have to do the lookup each time a document is created.
@GetProfileField("dbProfile";"Data")
This no longer works since I moved to R6. I get "ERROR: This function is inappropriate for file system directories."
Any ideas what has changed or away I can get around this problem?
Regards,
Vince